SELECT comp.codcompet, comp.libcompet,comp.codcla, datdeb, datfin FROM gcmatcom mat INNER JOIN gccompet comp on mat.codcompet = comp.codcompet WHERE mat.matricule = '13199' and datfin > '21/11/14' ORDER BY codcla